Overview: SQL Expressions

Filter selected fields by defining a WHERE clause in the SQL expression, indicating the conditions that need to be met in order for the values to be included in the new dataset. Only the fields selected will be listed in the new dataset.

You can then also order the values of the highest priority field in an ascending or descending order.

NOTE: CSense provides secure native blocks and operations for building analytics and solutions. The native capabilities provided by CSense can be extended by making use of this feature. When making use of this feature, please ensure that you have validated your extended functions to ensure that they perform as intended and do not introduce stability or security risks to your production system. Do not use scripts or components from untrusted sources.

Properties

Category:	Filter
Performance risk:	Low performance risk
Knowledge required:	Working knowledge of SQL

Effect on datasets

How many datasets are required to perform this operation?	One
Does it create a new dataset?	Yes
Can you reconfigure this operation?	Yes
Can you apply this operation to a locked dataset?	Yes
Does it modify the current dataset in any way?	No

Requirements

This operation needs a dataset with at least one field.

Results

A new dataset will be created with the filtered values. This dataset will only contain the selected fields used for filtering.
The dataset will be ordered if this option is selected and configured.